██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    
Sets - Execution started 16/01/2023 22:20 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data aquisition
    • 1.1  Fetch set lists
    • 1.2  Fetch set properties
    • 1.3  Merge data
    • 1.4  Save data
  • 3  Check changes
    • 3.1  Load previous data
    • 3.2  Generate changelog
  • 4  Data visualization
    • 4.1  Full data
    • 4.2  Set
    • 4.3  Card number
    • 4.4  Name
    • 4.5  Rarity
      • 4.5.1  By unique
      • 4.5.2  By combination
    • 4.6  Print
    • 4.7  Quantity
    • 4.8  Region
    • 4.9  Cover card
    • 4.10  Series
    • 4.11  Set type
    • 4.12  Release
      • 4.12.1  By year
      • 4.12.2  By month
      • 4.12.3  By day
      • 4.12.4  By region
      • 4.12.5  By series
      • 4.12.6  By set type
  • 5  Debug
    • 5.1  Has nan name/number
    • 5.2  Has nan rarity
    • 5.3  Has quantity as print
    • 5.4  Has nan release
    • 5.5  Has print as rarity
    • 5.6  Merge failed
  • 6  Epilogue
    • 6.1  HTML export

Data aquisition¶

Fetch set lists¶

  0%|          | 0/80 [00:00<?, ?it/s]
4119 set lists received - 75 errors

Fetch set properties¶

  0%|          | 0/96 [00:00<?, ?it/s]
1433 set properties received - 3 errors

Merge data¶

Set properties merged

Save data¶

Data saved

Check changes¶

Load previous data¶

File loaded

Generate changelog¶

Print Version
Card number
CL03-SC004 <NA> Old
CL03-SC004 New
CL03-SC005 New
CL03-SC005 <NA> Old
CL03-SC006 <NA> Old
... ... ...
CL03-SC188 <NA> Old
CL03-SC189 New
CL03-SC189 <NA> Old
CL03-SC190 <NA> Old
CL03-SC190 New

322 rows × 2 columns

Changelog saved

Data visualization¶

Full data¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
0 2-Player Starter Deck: Yuya & Declan YS15-PTY00 Odd-Eyes Saber Dragon (Ultra Rare,) <NA> <NA> PT 2015-05-29 <NA> Starter Deck (D/D/D Dragon King Pendragon, Odd-Eyes Saber D... 2020-11-08 22:53:12 both
1 2-Player Starter Deck: Yuya & Declan YS15-PTY01 Alexandrite Dragon (Common,) <NA> <NA> PT 2015-05-29 <NA> Starter Deck (D/D/D Dragon King Pendragon, Odd-Eyes Saber D... 2020-11-08 22:53:12 both
2 2-Player Starter Deck: Yuya & Declan YS15-PTY02 Mystical Elf (Common,) <NA> <NA> PT 2015-05-29 <NA> Starter Deck (D/D/D Dragon King Pendragon, Odd-Eyes Saber D... 2020-11-08 22:53:12 both
3 2-Player Starter Deck: Yuya & Declan YS15-PTY03 Odd-Eyes Dragon (Common,) <NA> <NA> PT 2015-05-29 <NA> Starter Deck (D/D/D Dragon King Pendragon, Odd-Eyes Saber D... 2020-11-08 22:53:12 both
4 2-Player Starter Deck: Yuya & Declan YS15-PTY04 Cyber Dragon (Common,) <NA> <NA> PT 2015-05-29 <NA> Starter Deck (D/D/D Dragon King Pendragon, Odd-Eyes Saber D... 2020-11-08 22:53:12 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
155887 Jump Festa 2010 - Promotion Pack JF10-JP008 Sweet Corn (Normal Parallel Rare,) <NA> <NA> JP 2009-12-19 <NA> Booster pack NaN 2022-07-26 20:28:32 both
155888 Jump Festa 2010 - Promotion Pack JF10-JP009 Vampiric Koala (Normal Parallel Rare,) <NA> <NA> JP 2009-12-19 <NA> Booster pack NaN 2022-07-26 20:28:32 both
155889 Jump Festa 2010 - Promotion Pack JF10-JP010 Koalo-Koala (Normal Parallel Rare,) <NA> <NA> JP 2009-12-19 <NA> Booster pack NaN 2022-07-26 20:28:32 both
155890 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155891 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only

155892 rows × 13 columns

Full data available here

Set¶

Total number of sets: 1438
Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Set
"Amabie-San" Present Campaign 2 1 1 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign 2 1 1 0 0 2 2 0 1 0 1 1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign 1 1 1 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition 0 1 0 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition 0 1 0 0 0 1 1 0 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card 1 1 1 0 0 1 1 0 1 0 1 1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards 18 3 1 0 0 6 2 0 1 0 1 1
Yugi's Legendary Decks 650 112 3 0 0 5 2 0 1 0 1 1
Zexal Collection Tin 120 24 3 0 0 5 1 0 1 1 1 1
Zombie World Structure Deck 185 37 2 0 2 5 1 0 1 1 1 1

1438 rows × 12 columns

Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
count 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.0
mean 106.800417 27.494437 2.428373 0.349096 0.099444 2.690542 1.454798 0.390125 0.953408 0.310153 0.994437 1.0
std 235.788887 45.313180 2.327728 0.813403 0.455981 2.296603 0.996361 0.487948 0.210838 0.462717 0.074406 0.0
min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.0
25% 1.000000 1.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.0
50% 10.000000 5.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.0
75% 86.000000 40.000000 3.000000 0.000000 0.000000 5.000000 2.000000 1.000000 1.000000 1.000000 1.000000 1.0
max 1652.000000 307.000000 17.000000 6.000000 3.000000 10.000000 9.000000 1.000000 1.000000 1.000000 1.000000 1.0

Card number¶

Total number of card numbers: 151713
Set Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Card number
15AX-JP000 2 1 1 1 0 1 1 0 1 0 2 1
15AX-JPM01 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM02 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM03 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM04 1 1 1 1 0 1 1 0 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
ZTIN-SP021 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV01 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV02 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV03 1 1 1 0 0 1 1 0 1 1 1 1
<NA> 44 406 6 2 0 10 40 6 11 6 43 3

151714 rows × 12 columns

Name¶

Total number of card names: 12572
Set Card number Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Name
"A Legendary Ocean" 1 1 0 0 0 1 1 0 1 1 1 1
"A" Cell Breeding Device 4 9 1 1 0 7 6 1 2 3 4 1
"A" Cell Incubator 2 8 1 2 0 7 6 1 1 2 2 1
"A" Cell Recombination Device 1 8 1 0 0 8 4 1 1 1 1 1
"A" Cell Scatter Burst 3 9 1 1 0 7 6 1 1 3 3 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Zubaba Knight 12 50 5 1 1 8 23 2 2 7 12 1
Zubababancho Gagagacoat 1 2 1 1 0 2 2 1 1 1 1 1
Zure, Knight of Dark World 8 24 1 1 1 10 14 1 4 4 8 1
Zushin the Sleeping Giant 3 14 3 1 0 8 4 1 2 3 3 1
<NA> 10 194 3 1 0 9 13 5 4 5 10 2

12573 rows × 12 columns

Set Card number Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
count 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000 12572.000000
mean 3.144846 12.053373 2.073258 0.670617 0.112393 6.880926 5.987273 1.089564 1.474069 1.844018 3.133551 1.010818
std 3.517214 11.600389 1.495081 0.672838 0.342446 2.567562 5.904821 0.787357 0.938340 1.842133 3.496589 0.103448
min 1.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000
25% 1.000000 7.000000 1.000000 0.000000 0.000000 6.000000 3.000000 1.000000 1.000000 1.000000 1.000000 1.000000
50% 2.000000 9.000000 2.000000 1.000000 0.000000 8.000000 4.000000 1.000000 1.000000 1.000000 2.000000 1.000000
75% 4.000000 14.000000 3.000000 1.000000 0.000000 8.000000 7.000000 1.000000 2.000000 2.000000 4.000000 1.000000
max 80.000000 275.000000 28.000000 4.000000 3.000000 15.000000 122.000000 12.000000 16.000000 41.000000 80.000000 2.000000

Rarity¶

Total number of rarities: 54

By unique¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Modification date _merge
Rarity
10000 Secret Rare 2 7 1 1 0 7 2 1 1 2 2 1
20th Secret Rare 16 135 134 3 0 1 13 3 3 6 16 1
@released::(from July 17) 1 1 1 0 0 1 0 0 0 0 1 1
@released::(from July 31) 1 1 1 0 0 1 0 0 0 0 1 1
@released::(from September 18) 1 2 1 0 0 1 0 0 0 0 1 1
Collector's Rare 6 226 76 2 0 7 6 2 1 6 6 1
Collectors Rare 8 112 112 2 0 1 8 1 1 7 8 1
Common 559 76881 8557 6 3 17 924 25 23 268 557 2
Duel Terminal Normal Parallel Rare 38 1906 511 2 0 7 34 1 3 11 38 1
Duel Terminal Normal Rare Parallel Rare 5 15 15 0 0 1 5 0 1 4 5 1
Duel Terminal Rare Parallel Rare 34 368 141 2 0 2 31 0 1 10 34 1
Duel Terminal Secret Parallel Rare 16 103 55 1 0 1 16 0 1 10 16 1
Duel Terminal Super Parallel Rare 34 240 85 2 0 2 31 0 1 10 34 1
Duel Terminal Ultra Parallel Rare 42 371 87 2 0 7 33 1 5 18 42 1
Extra Secret Parallel Rare 3 10 6 0 0 2 4 0 2 1 3 1
Extra Secret Rare 24 77 50 1 1 3 31 3 5 17 24 1
Ghost Rare 35 255 47 3 0 7 63 1 2 34 35 1
Ghost/Gold Rare 1 30 6 0 0 5 2 1 1 0 1 1
Gold Rare 23 2057 363 2 0 9 39 3 5 0 23 1
Gold Rush Rare 2 16 16 2 0 1 2 0 1 1 2 1
Gold Secret Rare 8 644 154 2 0 9 17 1 3 0 8 1
Holographic Parallel Rare 2 2 2 1 0 1 2 0 1 0 2 1
Holographic Rare 68 123 65 2 0 6 121 3 2 65 68 1
Kaiba Corporation Common 10 10 10 0 0 1 8 0 1 0 10 1
Kaiba Corporation Rare 5 5 5 0 0 1 5 1 2 0 5 1
Kaiba Corporation Ultra Rare 3 3 3 0 0 1 3 0 2 0 3 1
Millennium Gold Rare 2 9 6 2 0 2 2 0 1 2 2 1
Millennium Rare 8 316 152 3 0 3 9 2 6 2 8 1
Millennium Secret Rare 1 4 2 1 0 2 0 0 1 1 1 1
Millennium Super Rare 1 40 20 1 0 2 0 0 1 1 1 1
Millennium Ultra Rare 1 16 8 1 0 2 0 0 1 1 1 1
Mosaic Rare 1 1290 215 0 0 6 2 0 1 1 1 1
New 2 1 18 1 1 1 2 1 2 2 2 1
Normal Parallel Rare 134 2084 1006 4 1 4 166 7 10 61 134 1
Normal Rare 81 575 299 2 0 7 151 3 2 72 81 1
Orr 1 1 1 0 0 1 1 1 1 1 1 1
Platinum Secret Rare 2 24 4 0 0 6 4 0 1 2 2 1
Prismatic Secret Rare 40 1393 366 3 0 11 49 6 4 15 40 1
Rare 249 18507 3499 7 2 15 545 13 8 177 248 2
Reprint 6 0 35 0 0 1 6 3 1 1 6 1
Rush Rare 16 106 51 0 0 2 28 1 2 13 16 1
Secret Parallel Rare 2 12 6 1 0 2 4 0 1 0 2 1
Secret Rare 373 10357 2293 11 1 15 532 20 20 200 368 2
Shatterfoil Rare 4 1482 292 0 1 7 5 1 2 4 4 1
Short Print 56 1316 234 3 0 10 110 3 1 46 56 1
Starfoil Rare 6 2019 380 0 0 6 9 1 3 4 6 1
Starlight Rare 12 316 56 2 0 6 13 1 1 12 12 1
Super Parallel Rare 6 154 82 3 1 3 10 1 3 2 6 1
Super Rare 585 20188 3887 9 1 17 953 26 20 276 581 2
Super Short Print 1 35 5 1 0 7 0 1 1 1 1 1
Ultimate Rare 115 4315 847 2 1 11 278 5 6 85 114 2
Ultra Parallel Rare 67 279 170 3 1 7 63 4 7 20 66 2
Ultra Rare 784 17912 3171 7 2 17 1069 33 26 278 782 2
Ultra Secret Rare 1 0 6 0 0 1 1 1 1 0 1 1
NaN 37 397 367 3 0 6 31 6 9 5 36 3

By combination¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Modification date _merge
Rarity
(10000 Secret Rare,) 2 7 1 1 0 7 2 1 1 2 2 1
(20th Secret Rare,) 9 25 24 1 0 1 8 2 3 1 9 1
(@released::(from July 17),) 1 1 1 0 0 1 0 0 0 0 1 1
(@released::(from July 31),) 1 1 1 0 0 1 0 0 0 0 1 1
(@released::(from September 18),) 1 2 1 0 0 1 0 0 0 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare) 1 1 1 0 0 1 1 1 1 1 1 1
(Ultra Rare, Ultra Parallel Rare) 22 71 67 0 0 1 16 3 2 16 21 2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare) 5 5 5 0 0 1 3 2 1 3 5 1
(Ultra Secret Rare,) 1 0 6 0 0 1 1 1 1 0 1 1
NaN 37 397 367 3 0 6 31 6 9 5 36 3

125 rows × 12 columns

Print¶

Total number of prints: 18
Set Card number Name Rarity Quantity Region Release Series Set type Cover card Modification date _merge
Print
1 161 0 0 0 1 1 1 1 0 1 1
2 1 0 1 0 0 1 1 0 1 1 1 1
American debut 1 3 3 1 0 1 1 0 1 1 1 1
European & Oceanian debut 1 6 6 1 0 1 1 0 1 0 1 1
European debut 12 146 146 5 0 2 10 0 2 1 12 1
Functional errata 1 2 2 1 0 1 1 0 1 1 1 1
New 226 11563 3861 50 3 11 243 18 13 129 224 2
New art 1 4 2 1 0 2 2 0 1 1 1 1
New artwork 10 74 15 5 0 7 12 3 4 4 10 1
New artwork (renamed) 1 3 3 1 0 1 1 0 1 0 1 1
North American debut 2 4 4 2 0 2 2 0 2 0 2 1
Oceanian debut 1 1 1 1 0 1 1 0 1 0 1 1
Reprint 223 13915 4287 49 3 11 240 17 12 127 221 2
Reprint (New Art) 2 2 1 2 0 2 2 1 1 1 2 1
Reprint (functional errata) 15 33 21 10 0 8 14 3 3 5 15 1
Reprint (new artwork) 1 1 1 1 0 1 1 0 1 1 1 1
Reprint (renamed) 2 76 76 6 0 1 2 1 1 0 2 1
TCG legal debut 1 1 1 1 0 1 1 1 1 1 1 1
<NA> 1358 125895 11472 113 3 17 1451 41 37 315 1350 3

Quantity¶

Total number of quantities: 3
Set Card number Name Rarity Print Region Release Series Set type Cover card Modification date _merge
Quantity
1 67 8858 1215 11 2 11 108 1 6 46 66 2
2 66 855 173 4 2 11 108 1 6 45 65 2
3 10 74 25 1 2 8 12 0 4 8 10 1
<NA> 1373 141938 12463 123 18 17 1501 45 36 314 1365 3

Region¶

Total number of regions: 17
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Modification date _merge
Region
AE 34 1527 1493 12 0 2 31 2 7 19 34 1
AU 2 100 87 3 0 0 1 0 1 2 2 1
DE 454 20312 10354 45 4 3 380 12 18 218 453 2
EN 657 20183 10480 51 14 3 535 22 23 207 656 2
ES 1 100 100 7 0 0 0 1 1 1 1 1
EU 25 543 456 8 3 0 16 2 9 6 25 1
FC 3 102 87 3 0 0 1 0 2 2 3 1
FR 448 19719 10341 46 4 3 375 14 18 218 447 2
IT 446 19991 10349 46 4 3 377 12 18 217 445 2
JA 3 185 185 8 0 0 3 2 2 3 3 1
JP 718 19113 11206 92 7 3 530 28 28 247 713 2
KR 383 15937 10754 55 4 3 333 16 15 224 378 2
NA 47 1526 1333 10 4 2 39 5 11 12 47 1
PT 203 12401 7783 40 4 3 164 8 10 119 203 1
SC 23 1237 1032 12 3 0 23 5 1 12 23 1
SP 415 19051 10181 45 4 3 354 9 17 203 414 2
TC 7 300 286 12 0 2 5 2 2 3 7 1
<NA> 2 0 0 0 0 0 0 0 0 0 2 1
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Modification date _merge
count 18.000000 18.000000 18.000000 18.00000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000
mean 215.055556 8462.611111 4805.944444 27.50000 3.055556 1.666667 175.944444 7.777778 10.166667 95.166667 214.222222 1.388889
std 252.650298 9273.573790 5007.035174 25.53717 3.489012 1.414214 203.421750 8.156957 8.759868 105.505088 251.558800 0.501631
min 1.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000 1.000000
25% 4.000000 213.750000 210.250000 8.00000 0.000000 0.000000 3.500000 2.000000 2.000000 3.000000 4.000000 1.000000
50% 40.500000 1526.500000 1413.000000 12.00000 3.500000 2.000000 35.000000 5.000000 9.500000 15.500000 40.500000 1.000000
75% 438.250000 19097.500000 10347.000000 45.75000 4.000000 3.000000 369.750000 12.000000 17.750000 214.500000 437.250000 2.000000
max 718.000000 20312.000000 11206.000000 92.00000 14.000000 3.000000 535.000000 28.000000 28.000000 247.000000 713.000000 2.000000

Cover card¶

Total number of cover cards: 671
Set Card number Name Rarity Print Quantity Region Release Series Set type Modification date _merge
Cover card
A-to-Z-Dragon Buster Cannon 1 352 54 4 2 2 8 4 0 1 1 1
Accel Synchro Stardust Dragon 1 100 50 3 2 0 2 2 0 1 1 1
Accesscode Talker 1 766 101 16 2 0 8 3 1 1 1 1
Adamancipator Risen - Dragite 1 135 45 3 2 0 3 3 0 1 1 1
Adreus, Keeper of Armageddon 1 84 42 4 0 0 2 2 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yamiterasu the Divine Ruler 1 132 66 6 0 0 2 2 1 1 1 1
Yoko, the Graceful Mayakashi 2 450 60 4 2 0 8 3 0 1 2 1
Yubel - The Ultimate Nightmare 2 560 100 10 0 0 6 5 1 2 2 1
Z-Metal Tank 1 55 55 7 0 0 1 1 1 1 1 1
Zerrziel, Ruler of the Evil Eyed 1 90 45 3 2 0 2 2 0 1 1 1

671 rows × 12 columns

Series¶

Total number of series: 45
Set Card number Name Rarity Print Quantity Region Release Set type Cover card Modification date _merge
Series
+1 Bonus Pack 7 249 137 3 0 0 2 12 1 0 7 1
Animation Chronicle 2 200 100 7 2 0 2 4 1 2 2 1
Astral Pack 7 1110 184 4 4 0 6 16 1 0 7 1
Attribute Duelist Pack 4 429 199 6 3 0 3 9 1 4 4 1
Battle Pack (Rush Duel) 8 80 80 3 3 0 1 8 1 0 8 1
Booster (series) 4 181 176 8 0 0 1 4 1 2 4 1
Booster pack 1 50 50 3 0 0 1 1 1 0 1 1
Champion Pack 8 640 161 4 2 0 4 8 1 0 8 1
Classic Pack 3 570 409 9 3 0 1 3 1 2 3 1
Collectors Pack 8 794 374 12 3 0 3 16 1 8 8 1
Core Booster 88 49929 7471 39 2 0 14 296 1 80 88 1
Deck Build Pack 3 360 134 5 2 0 3 8 1 3 3 1
Deck Mod Pack 12 1447 750 8 0 0 2 23 1 12 12 1
Duelist Pack 21 3739 634 7 3 0 8 49 1 19 21 1
Entry Pack (series) 10 163 160 3 2 0 1 10 1 0 10 1
Expansion Pack 4 280 280 6 0 0 1 4 1 0 4 1
Gold Series (series) 8 2595 446 9 2 0 9 18 1 0 8 1
Hidden Arsenal (series) 7 2470 400 2 2 0 7 16 1 7 7 1
Hobby League 1 83 43 3 0 0 5 0 1 0 1 1
Jump Victory Carnival 1 1 1 1 0 0 1 1 1 0 1 1
Legend Duelist (series) 6 780 343 9 2 0 3 14 1 6 6 1
Legendary Collection (series) 2 57 19 1 2 0 3 4 1 0 2 1
Master Guide promotional cards (series) 4 8 8 1 0 0 1 4 1 0 4 1
Mattel Action Figure promotional cards 3 17 16 1 0 0 1 3 1 0 3 1
McDonald's Promotional Cards 2 35 35 4 3 0 2 2 1 0 2 1
Monster Figure Collection promotional cards 3 15 15 1 0 0 1 3 1 0 3 1
OTS Tournament Pack 2 324 54 4 0 0 6 3 1 0 2 1
Perfect Rulebook promotional cards 3 3 3 2 0 0 1 3 1 0 3 1
Pharaoh Tour promotional cards 3 20 5 2 0 0 4 3 1 0 3 1
Premium Pack 25 452 368 9 3 0 2 25 1 12 25 1
Shonen Jump promotional cards 78 85 81 2 0 0 2 44 1 0 78 1
Sneak Peek Participation Cards 57 302 61 2 0 0 8 69 1 0 57 1
Star Pack 3 900 149 4 0 0 6 6 1 3 3 1
Structure Deck R 3 248 122 5 2 2 2 6 1 3 3 1
The Valuable Book promotional cards 18 38 38 2 0 0 2 19 1 0 18 1
V Jump August 1999 Special Present 1 0 6 1 0 0 1 1 1 0 1 1
V Jump Edition (series) 4 16 16 3 0 0 1 4 1 0 4 1
V Jump promotional cards 78 94 98 5 0 0 1 74 1 0 78 1
Value Box 9 11 11 3 0 0 1 7 1 0 9 1
Yu-Gi-Oh! 5D's manga promotional cards 9 19 9 1 0 0 3 18 1 0 9 1
Yu-Gi-Oh! Day promotional cards 7 7 1 1 0 0 2 7 1 0 7 1
Yu-Gi-Oh! GX manga promotional cards 9 19 9 2 0 0 3 17 1 0 9 1
Yu-Gi-Oh! R promotional cards 4 8 4 2 0 0 2 8 1 0 4 1
Yu-Gi-Oh! World Championship prize cards 13 35 30 5 0 0 3 13 1 0 13 1
Yu-Gi-Oh! ZEXAL manga promotional cards 8 25 8 1 0 0 4 25 1 0 8 1

Set type¶

Total number of set types: 37
Set Card number Name Rarity Print Quantity Region Release Series Cover card Modification date _merge
Set type
Beta set 1 535 106 1 0 2 5 1 0 0 1 1
Binder 2 6 6 2 2 0 1 2 0 0 2 1
Book promotional card 4 5 5 3 0 0 2 4 1 0 4 1
Book promotional cards 26 52 52 4 0 0 2 27 2 0 26 1
Booster pack 469 113732 11757 102 16 0 15 809 23 223 469 1
Boss Duel Deck 1 8 8 1 0 0 1 1 0 0 1 1
Bundle 9 11 11 3 0 0 1 7 1 0 9 1
Collectible tin 53 5901 1005 9 4 0 8 66 0 35 53 1
Collector's Set 11 6226 1102 7 2 3 7 14 0 6 11 1
Core Booster 1 160 80 6 0 0 2 2 0 1 1 1
Deluxe Edition 4 114 19 2 0 0 6 8 0 4 4 1
Demo Deck 4 380 64 1 0 0 7 8 0 1 4 1
Duel Disk 2 16 9 2 2 0 2 4 0 0 2 1
Duel Disk promotional cards 5 13 12 4 0 0 2 5 0 0 5 1
Duel Terminal 34 1847 706 6 2 0 2 31 0 10 34 1
Duelist League participation cards 10 60 16 3 0 0 9 9 0 0 10 1
Duelist Set 5 312 154 5 0 2 2 5 0 5 5 1
Enhancement Pack 2 20 20 1 0 0 1 1 0 0 2 1
Hobby League participation cards 40 83 43 3 0 0 5 38 0 0 40 1
Magazine promotional card 167 191 173 9 0 0 3 127 3 7 167 1
Magazine promotional cards 4 4 4 1 0 0 2 2 0 0 4 1
Main Deck 2 44 44 2 0 0 1 2 0 1 2 1
Manga promotional card 33 74 32 2 0 0 4 69 4 0 33 1
Participation card 60 485 119 5 0 0 9 71 2 0 60 1
Preconstructed Deck 6 401 223 10 3 3 2 8 0 4 6 1
Prize card 16 46 41 5 0 0 3 16 1 0 16 1
Prize cards 1 68 20 1 0 0 5 1 0 0 1 1
Promotional card 141 320 212 18 3 0 9 142 6 21 141 1
Promotional cards 25 200 62 7 2 0 10 34 1 1 25 1
Special Edition 90 1189 289 9 5 0 10 109 0 1 90 1
Starter Deck 38 6777 606 11 3 3 14 59 0 26 38 1
Structure Deck 64 9454 1206 9 2 3 10 117 1 45 64 1
Tournament prize card 1 2 2 1 0 0 1 1 0 0 1 1
Tournament promotional card 2 5 2 2 0 0 2 2 0 0 2 1
Vendor Edition 6 210 210 2 0 0 1 6 0 0 6 1
Video game promotional card 9 79 39 4 0 0 8 15 0 0 9 1
Video games promotional card 23 328 73 4 2 0 9 44 0 0 23 1

Release¶

Total number of release dates: 1572
Set Card number Name Rarity Print Quantity Region Series Set type Cover card Modification date _merge
Release
1999-03-01 1 0 40 1 0 0 1 1 1 0 1 1
1999-03-18 1 0 1 0 0 0 1 0 1 0 1 1
1999-04-29 1 0 1 0 0 0 1 0 1 0 1 1
1999-05-05 1 0 1 0 0 0 1 0 1 0 1 1
1999-05-25 1 0 40 1 0 0 1 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
2023-01-21 1 67 61 7 0 0 1 1 1 1 1 1
2023-02-25 1 190 29 5 3 0 1 1 1 0 1 1
2023-03-01 3 2 3 2 0 0 1 0 1 0 3 1
2023-05-01 3 3 3 1 0 0 1 0 1 0 3 1
NaT 120 4071 1175 28 4 2 14 9 13 15 112 3

1573 rows × 12 columns

By year¶

Set Card number Name Rarity Print Quantity Region Series Set type Cover card _merge
Release
1999 18 0 353 10 2 0 15 8 15 1 15
2000 11 268 318 21 2 2 9 7 10 4 9
2001 13 311 313 30 7 4 13 5 12 7 13
2002 22 1369 1197 81 10 2 21 9 20 14 19
2003 52 2672 2266 124 12 0 53 12 42 29 38
2004 93 6502 4687 193 6 0 108 27 74 45 59
2005 75 7826 4043 160 27 18 127 28 64 37 49
2006 102 5244 3048 186 22 20 125 39 93 42 67
2007 127 5747 3347 273 16 18 192 53 116 54 94
2008 125 5989 3258 269 21 12 194 51 113 50 95
2009 118 5114 2983 280 6 14 172 40 111 54 93
2010 138 6093 3322 309 8 16 204 58 124 53 103
2011 144 6922 3952 318 16 18 214 55 133 53 105
2012 141 10271 5425 349 17 20 218 57 128 53 111
2013 146 8813 4469 340 18 24 221 68 129 69 108
2014 141 12625 5705 381 38 20 225 68 126 60 107
2015 136 10432 4828 353 33 12 221 69 125 57 103
2016 137 10356 4755 331 39 10 210 62 124 59 97
2017 67 8404 3324 198 27 6 140 29 64 35 54
2018 46 5413 2129 140 26 0 103 20 41 28 41
2019 50 6264 2670 160 29 0 101 17 45 25 43
2020 38 6435 2143 150 34 0 85 18 36 27 36
2021 65 6812 2733 241 46 6 91 38 53 36 49
2022 73 8953 3673 249 66 6 96 43 61 42 56
2023 14 497 331 40 8 0 9 7 8 4 8

By month¶

By day¶

By region¶

Set Card number Name Rarity Print Quantity Series Set type Cover card Modification date _merge
Region Release
AE 2001-06-04 1 0 2 0 0 0 0 0 0 1 1
2002-08-08 2 100 87 3 0 0 0 1 2 2 1
2002-10-24 1 144 144 5 0 0 1 1 1 1 1
2003-04-17 1 3 3 1 0 0 0 1 0 1 1
2003-06-26 1 105 105 5 0 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
TC 2014-01-29 1 40 40 4 0 2 0 1 1 1 1
2014-05-01 1 20 20 4 0 0 1 1 0 1 1
2015-03-01 2 40 26 1 0 0 0 0 0 2 1
2015-08-29 1 100 100 6 0 0 1 1 1 1 1
2015-12-05 1 100 100 6 0 0 1 1 1 1 1

3167 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Region
AE 0 0 1 3 4 3 3 5 2 1 ... 1 1 0 0 0 0 0 0 0 0
AU 0 0 0 0 2 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
DE 0 0 0 0 8 21 22 17 31 27 ... 30 27 28 20 15 13 10 8 7 0
EN 0 0 2 2 3 16 29 48 50 45 ... 43 34 35 20 15 13 10 12 11 1
EU 0 0 0 2 2 4 0 0 0 2 ... 2 2 1 0 0 0 0 0 0 0
FC 0 0 0 0 2 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
FR 0 0 0 0 6 20 22 17 31 27 ... 28 27 28 19 15 13 10 8 7 0
IT 0 0 0 0 5 20 21 17 31 27 ... 28 27 28 20 15 13 10 8 7 0
JA 0 0 0 0 0 0 0 0 0 0 ... 3 0 0 0 0 0 0 0 0 0
JP 18 11 10 11 11 20 24 27 33 41 ... 43 43 52 14 16 20 14 25 26 10
KR 0 0 0 0 2 8 7 13 20 24 ... 23 22 21 17 10 12 10 23 26 1
NA 0 0 0 5 16 6 0 2 2 1 ... 2 3 0 2 0 0 0 0 0 0
PT 0 0 0 0 0 10 6 0 0 0 ... 24 25 26 18 14 13 9 8 7 0
SC 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 4 7 10 2
SP 0 0 0 0 4 20 20 10 24 22 ... 28 27 28 19 14 13 10 9 7 0
TC 0 0 0 0 0 0 0 0 0 0 ... 2 4 0 0 0 0 0 0 0 0

16 rows × 25 columns

By series¶

Set Card number Name Rarity Print Quantity Region Set type Cover card Modification date _merge
Series Release
+1 Bonus Pack 2020-10-31 1 19 19 3 0 0 1 1 0 1 1
2021-02-04 1 20 20 3 0 0 1 1 0 1 1
2021-04-17 1 19 19 3 0 0 1 1 0 1 1
2021-07-17 1 19 19 3 0 0 1 1 0 1 1
2021-07-21 1 19 19 3 0 0 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL manga promotional cards 2015-09-01 1 1 1 1 0 0 1 1 0 1 1
2015-10-03 1 1 1 1 0 0 1 1 0 1 1
2015-12-18 1 1 1 1 0 0 1 1 0 1 1
2016-03-01 1 1 1 1 0 0 1 1 0 1 1
2016-09-06 1 1 1 1 0 0 1 1 0 1 1

888 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Series
+1 Bonus Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 1 6 4 1
Animation Chronicle 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 2 2 0
Astral Pack 0 0 0 0 0 0 0 0 0 0 ... 8 3 0 0 0 0 0 0 0 0
Attribute Duelist Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 2 3 4 0
Battle Pack (Rush Duel) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 3 4 1
Booster (series) 0 3 1 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Booster pack 0 1 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Champion Pack 0 0 0 0 0 0 0 1 3 3 ... 0 0 0 0 0 0 0 0 0 0
Classic Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 2 1
Collectors Pack 0 0 0 0 0 0 0 0 0 0 ... 2 2 2 2 2 2 2 0 0 0
Core Booster 6 0 2 6 11 22 17 17 25 13 ... 16 17 16 12 10 8 6 8 8 1
Deck Build Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 2 6 0
Deck Mod Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 4 9 8 2
Duelist Pack 0 0 0 0 0 0 2 9 9 10 ... 1 3 5 1 0 0 0 0 0 0
Entry Pack (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 1 4 4 1
Expansion Pack 0 0 0 0 0 0 0 0 0 3 ... 0 0 0 0 0 0 0 0 0 0
Gold Series (series) 0 0 0 0 0 0 0 0 0 2 ... 5 2 2 0 0 0 0 0 0 0
Hidden Arsenal (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Jump Victory Carnival 0 0 0 0 0 0 0 0 0 0 ... 0 1 0 0 0 0 0 0 0 0
Legend Duelist (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 3 4 4 1 1 1 0
Legendary Collection (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Master Guide promotional cards (series) 0 0 0 0 0 1 0 0 0 1 ... 1 0 0 0 0 0 0 0 0 0
Mattel Action Figure promotional cards 0 0 0 0 0 0 0 3 0 0 ... 0 0 0 0 0 0 0 0 0 0
McDonald's Promotional Cards 0 0 0 1 0 0 0 1 0 0 ... 0 0 0 0 0 0 0 0 0 0
Monster Figure Collection promotional cards 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
OTS Tournament Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 3 0 0 0 0 0 0 0
Perfect Rulebook promotional cards 0 0 0 0 0 0 0 0 0 0 ... 1 1 1 0 0 0 0 0 0 0
Pharaoh Tour promotional cards 0 0 0 0 0 0 1 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Premium Pack 0 2 2 0 0 3 1 1 1 2 ... 2 2 0 0 0 0 0 0 0 0
Shonen Jump promotional cards 0 0 0 0 0 0 2 3 4 3 ... 6 4 6 1 0 0 0 0 0 0
Sneak Peek Participation Cards 0 0 0 0 0 0 4 4 9 8 ... 4 4 5 5 3 2 1 0 0 0
Star Pack 0 0 0 0 0 0 0 0 0 0 ... 1 2 0 0 0 0 0 0 0 0
Structure Deck R 0 0 0 0 0 0 0 0 0 0 ... 0 1 4 1 0 0 0 0 0 0
The Valuable Book promotional cards 1 1 0 2 1 1 1 1 1 1 ... 1 1 0 1 0 0 0 0 0 0
V Jump August 1999 Special Present 1 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
V Jump Edition (series) 0 0 0 0 0 0 0 0 0 0 ... 0 1 1 0 1 1 0 0 0 0
V Jump promotional cards 0 0 0 0 0 0 0 0 0 5 ... 8 11 13 2 0 0 0 0 0 0
Value Box 0 0 0 0 0 0 0 0 0 0 ... 1 1 0 0 0 0 0 0 0 0
Yu-Gi-Oh! 5D's manga promotional cards 0 0 0 0 0 0 0 0 0 0 ... 3 3 1 0 0 0 0 0 0 0
Yu-Gi-Oh! Day promotional cards 0 0 0 0 0 0 0 0 0 0 ... 2 2 2 1 0 0 0 0 0 0
Yu-Gi-Oh! GX manga promotional cards 0 0 0 0 0 0 0 1 2 3 ... 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! R promotional cards 0 0 0 0 0 0 1 1 1 1 ... 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! World Championship prize cards 0 0 0 0 0 1 1 1 1 1 ... 1 1 1 0 0 0 0 0 0 0
Yu-Gi-Oh! ZEXAL manga promotional cards 0 0 0 0 0 0 0 0 0 0 ... 6 7 2 0 0 0 0 0 0 0

44 rows × 25 columns

By set type¶

Set Card number Name Rarity Print Quantity Region Series Cover card Modification date _merge
Set type Release
Beta set 2017-10-04 1 535 106 1 0 2 5 0 0 1 1
Binder 2012-09-21 1 3 3 1 2 0 1 0 0 1 1
2015-04-29 1 3 3 1 0 0 1 0 0 1 1
Book promotional card 2004-12-18 1 2 2 1 0 0 1 0 0 1 1
2014-04-04 1 1 1 1 0 0 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Video games promotional card 2011-04-28 1 7 7 1 0 0 1 0 0 1 1
2011-05-10 1 3 3 1 0 0 1 0 0 1 1
2013-12-05 1 3 3 1 0 0 1 0 0 1 1
2014-06-26 1 15 3 1 0 0 5 0 0 1 1
2016-07-16 1 1 1 1 0 0 1 0 0 1 1

1867 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Set type
Beta set 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 1 0 0 0 0 0 0
Binder 0 0 0 0 0 0 0 0 0 0 ... 0 1 0 0 0 0 0 0 0 0
Book promotional card 0 0 0 0 0 1 0 0 0 0 ... 1 1 1 0 0 0 0 0 0 0
Book promotional cards 1 2 0 2 1 2 1 1 1 2 ... 2 2 1 1 0 0 0 0 0 0
Booster pack 6 6 5 10 15 40 34 36 44 44 ... 65 56 52 38 28 31 31 52 53 8
Boss Duel Deck 0 0 0 0 0 0 0 0 0 0 ... 1 0 0 0 0 0 0 0 0 0
Bundle 0 0 0 0 0 0 0 0 0 0 ... 1 1 0 0 0 0 0 0 0 0
Collectible tin 0 0 0 1 2 2 2 3 3 7 ... 2 2 2 2 1 2 1 1 1 0
Collector's Set 0 0 0 0 0 0 0 0 0 0 ... 0 2 2 0 0 3 2 1 4 0
Core Booster 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Deluxe Edition 0 0 0 0 0 0 0 0 0 0 ... 6 0 0 0 0 0 0 0 0 0
Demo Deck 0 0 0 0 0 0 0 0 0 0 ... 0 2 2 0 3 0 0 0 0 0
Duel Disk 0 0 0 0 0 0 0 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Duel Disk promotional cards 0 0 0 0 0 0 0 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Duel Terminal 0 0 0 0 0 0 0 0 0 6 ... 0 0 0 0 0 0 0 0 0 0
Duelist League participation cards 0 0 0 0 4 4 2 2 0 0 ... 0 0 0 0 0 0 0 0 0 0
Duelist Set 0 0 0 0 0 0 0 0 0 0 ... 1 0 0 0 0 0 0 0 0 0
Enhancement Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Hobby League participation cards 0 0 0 0 0 2 1 13 12 12 ... 0 0 0 0 0 0 0 0 0 0
Magazine promotional card 1 0 0 0 0 0 3 3 4 10 ... 14 15 20 3 0 0 0 0 0 0
Magazine promotional cards 0 0 0 0 1 1 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Main Deck 0 0 0 0 0 0 0 0 0 1 ... 0 0 0 0 0 0 0 0 0 0
Manga promotional card 0 0 0 1 0 0 1 4 3 4 ... 9 10 3 0 0 0 0 0 0 0
Participation card 1 0 0 0 0 0 4 4 9 8 ... 4 4 5 5 3 2 1 0 0 0
Preconstructed Deck 0 0 0 0 0 0 0 0 0 0 ... 1 1 1 1 1 1 0 0 4 0
Prize card 0 0 2 0 0 1 1 1 1 1 ... 1 1 1 0 0 0 0 0 0 0
Prize cards 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Promotional card 2 0 2 1 0 1 1 9 9 5 ... 5 7 17 5 3 6 2 9 11 6
Promotional cards 2 0 1 1 5 7 2 1 0 0 ... 2 1 0 0 0 1 0 0 0 0
Special Edition 0 0 0 0 2 3 3 7 12 11 ... 3 7 8 7 4 2 1 0 0 0
Starter Deck 1 1 0 4 13 18 2 0 3 2 ... 5 7 4 0 0 0 0 2 0 0
Structure Deck 0 0 2 1 3 0 8 10 8 6 ... 11 13 17 4 0 0 0 0 0 0
Tournament prize card 0 0 0 0 1 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Tournament promotional card 0 0 0 0 1 0 1 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Vendor Edition 0 0 0 0 0 1 2 2 1 0 ... 0 0 0 0 0 0 0 0 0 0
Video game promotional card 1 2 0 0 0 0 0 0 5 0 ... 0 0 0 0 0 0 0 0 0 0
Video games promotional card 0 0 0 1 4 8 7 4 8 4 ... 1 0 1 0 0 0 0 0 0 0

37 rows × 25 columns

Debug¶

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
3410 Extreme Victory <NA> <NA> (Common,) <NA> <NA> DE 2011-05-05 Core Booster Booster pack (Junk Berserker,) 2022-07-23 10:28:05 both
3511 Extreme Victory <NA> <NA> (Common,) <NA> <NA> JP 2011-02-11 Core Booster Booster pack (Junk Berserker,) 2022-07-23 10:28:05 both
3592 Extreme Victory <NA> <NA> (Common,) <NA> <NA> SP 2011-05-05 Core Booster Booster pack (Junk Berserker,) 2022-07-23 10:28:05 both
3693 Extreme Victory <NA> <NA> (Common,) <NA> <NA> KR 2011-06-10 Core Booster Booster pack (Junk Berserker,) 2022-07-23 10:28:05 both
3774 Extreme Victory <NA> <NA> (Common,) <NA> <NA> EN 2011-05-06 Core Booster Booster pack (Junk Berserker,) 2022-07-23 10:28:05 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
144883 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144884 EX Starter Box <NA> Castle Walls None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144885 EX Starter Box <NA> Ultimate Offering None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
155890 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155891 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only

753 rows × 13 columns

Has nan rarity¶

array(['Dark Beginning 2', 'Dark Revelation Volume 1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome attendance cards',
       'Yu-Gi-Oh! True Duel Monsters: Sealed Memories promotional cards',
       'Dark Beginning 1', 'Advanced Tournament Pack 2013 Vol.3',
       'V Jump April 2013 Tokens',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome invitation cards',
       'Dark Revelation Volume 2',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome prize cards',
       'Advanced Tournament Pack 2013 Vol.4',
       'Official Guide Starter Book promotional card',
       'Starter Box pre-order promotional card',
       'Advanced Event Pack 2013 Vol.2',
       'Duel Monsters II tournament meeting experience promotional card',
       'The Valuable Book 1 promotional cards', 'Jump Festa 2000',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome participation cards',
       'The Valuable Book character cards',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Event Pack 2014 Vol.1',
       '"Blue-Eyes White Dragon" 20th Anniversary Gold Edition',
       '"Blue-Eyes White Dragon" 20th Anniversary Silver Edition',
       '"Dark Magician" Special Card',
       '"Dark Magician Girl" Special Card',
       '25th Anniversary Ultimate Kaiba Set',
       'Asian-English Weekly Shōnen Jump lottery prize cards',
       'Booster 1', 'Booster 3',
       'Challenge from Kaiba Corporation Clear bonus',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Classic Pack 03', 'Deck Build Pack: Tactical Masters',
       'Deck Mod Pack: Double Star of the Assault!!', 'EX Starter Box',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)

Has quantity as print¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
144834 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144883 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
144786 EX Starter Box <NA> Lord of D. (New,) <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144787 EX Starter Box <NA> The Flute of Summoning Dragon (New,) <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144788 EX Starter Box <NA> Dark Magician None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144789 EX Starter Box <NA> Mystical Elf None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144790 EX Starter Box <NA> Feral Imp None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
144881 EX Starter Box <NA> Reverse Trap None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144882 EX Starter Box <NA> Remove Trap None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144883 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144884 EX Starter Box <NA> Castle Walls None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144885 EX Starter Box <NA> Ultimate Offering None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both

100 rows × 13 columns

Has nan release¶

array(['Ancient Prophecy Sneak Peek Participation Card',
       'Ancient Sanctuary',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Millennium Pack', 'National Championship 2011',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'The New Challengers Sneak Peek Participation Card',
       'Tournament Pack 2009 Vol.3',
       "Yu-Gi-Oh! 5D's manga promotional cards", 'Curse of Anubis',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E',
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Crossed Souls Sneak Peek Participation Card',
       'Sneak Peek Participation Cards', 'Spell Ruler',
       'Academy Duel Disk', 'Cosmo Blazer',
       'The Lost Millennium: Special Edition',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Astral Pack Two', 'Tournament Pack 2008 Vol.2',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Premium Pack 2', 'Raging Battle Sneak Peek Participation Card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'National Championship 2012', 'Premium Pack',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       'Hobby League 6 participation card F', 'Magic Ruler',
       'Gold Series', 'Invasion: Vengeance Sneak Peek Participation Card',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Astral Pack One', 'Duelist League Demo 2010',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Hobby League 6 participation card A',
       'Shonen Jump December 2010 subscription bonus',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Shonen Jump May 2006 subscription bonus',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Yu-Gi-Oh! R promotional cards',
       'Hobby League participation cards', 'National Championship 2013',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Tournament Pack 2009 Vol.4',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Structure Deck: Marik', 'Hobby League 7 participation card A',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Hobby League 6 participation card B',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'Shonen Jump August 2008 subscription bonus',
       'The Valuable Book promotional cards', 'The Sanctuary in the Sky',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Tournament Pack 2008 Vol.1',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Hobby League 6 participation card C',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shonen Jump May 2010 subscription bonus',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Invader of Darkness',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Ultimate Edition',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Banzai! promotional cards', 'Hobby League 7 participation card C',
       'Hobby League 6 participation card D',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card', 'Duel Disk',
       'The Valuable Book character cards',
       'Hobby League 7 participation card D',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       '2013 Collectible Tins', '20th Anniversary Duel Set',
       'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has print as rarity¶

array(['Booster 5', 'Booster 6',
       'Structure Deck R: Machine Dragon Re-Volt', 'Booster 7',
       'Dark Ceremony Edition', 'Booster 4', 'Booster 1',
       'EX Starter Box'], dtype=object)

Merge failed¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
155890 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155891 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only
8
array(['2-Player Starter Deck: Yuya & Declan', '2014 Mega-Tins',
       'Absolute Powerforce', ..., 'Jump Festa 2010 - Promotion Pack',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge

Epilogue¶

Execution completed 16/01/2023 22:29 UTC

HTML export¶

Notebook saved to disk